-- @owner: zhanghuan
-- @date: 2024-18-06
-- @testpoint: 构建初始表及数据

--step1:建表;expect:成功
drop table if exists t_ustore_ASIN_case1;
create table t_ustore_ASIN_case1(COL_1 bigint, COL_2 TIMESTAMP WITHOUT TIME ZONE,
COL_3 bool,COL_4 decimal,COL_5 text, COL_6 smallint, COL_7 char(30), COL_8 double precision,
COL_9 text,COL_10 character varying(30), COL_11 boolean, COL_12 bytea, COL_13 real,
COL_14 numeric, COL_15 blob, COL_16 integer, COL_17 int,COL_18 TIMESTAMP WITH TIME ZONE,
COL_19 binary_integer, COL_20 interval day to second,COL_21 boolean, COL_22 nchar(30),
COL_23 bigint, COL_24 nchar(100),COL_25 character(1000), OL_26 text, COL_27 float,
COL_28 double precision, COL_29 bigint,COL_30  TIMESTAMP WITH TIME ZONE, COL_31 TIMESTAMP,
COL_32 clob, COL_33 interval year to month,COL_34 character(30), COL_35 smallint, COL_36 blob,
COL_37 char(300), COL_38 float,COL_39 raw(100), COL_40 clob, COL_41 binary_double,
COL_42 number(6,2), COL_43 decimal(6,2),COL_44 varchar2(50), COL_45 varchar(30),
COL_46 nvarchar2(100), COL_47 numeric(12,6), COL_48 varchar2(50),COL_49 date, COL_50 clob,
COL_51 integer, COL_52 binary_double, COL_53 decimal(12,6), COL_54 raw(8000),COL_55 clob,
COL_56 varchar2(8000), COL_57 date, COL_58 number(12,6), COL_59 nvarchar2(4000), COL_60 clob,
COL_61 blob, COL_62 date, COL_63 blob, COL_64 varchar(1000), COL_65 date, COL_66 float,
COL_67 float) WITH (STORAGE_TYPE=USTORE);

--step2:创建序列并清空表;expect:成功
drop sequence if exists seq_ASIN2_case1;
create sequence seq_ASIN2_case1 increment by 1 start with 100000;
truncate table t_ustore_ASIN_case1;

--step3:插入数据;expect:成功
begin for i in 1..1000 loop
insert into t_ustore_ASIN_case1 values(seq_ASIN2_case1.nextval,
to_timestamp('2019-01-03 14:58:54.000000', 'YYYY-MM-DD HH24:MI:SS.FFFFFF'),
true,3.1415926, lpad('abc','30','a@123&^%djgk'), 987, 'asjk&%$454', 10011.456789445455,
lpad('abc','50','a@123&^%djgk'), '字符串', false, '1001011', 315454.1415926, 99/4,
'101101000111111101010', 0, 1, to_timestamp('2019-01-04 16:33:47.123456','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
'1', (INTERVAL '4 5:12:10.222' DAY TO SECOND(3)), 0, rpad('abc','10','e'),
353848,rpad('abc','10','exc'), lpad('abc','30','a@123&^%djgk'), lpad('abc','20','a@123&^%djgk'),
9745.548, -99, 3141.5, to_timestamp('2019-01-04 16:33:47.123456','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
to_timestamp('2019-01-03 14:58:54.000000','YYYY-MM-DD HH24:MI:SS.FFFFFF'),
'a@123&^%djgk',(INTERVAL '12' YEAR), ' ', '0', '101101000111111101010', '这是一个字符串', 1/2.15,
'0FAADB9', 'a@123&^%djgk',1.0E+100, 3.14, 4445.25, rpad('abc','10','&'), lpad('abc','10','&'),
'abc&GDsh', 125563.141592,rpad('abc','10','e'), '2019-01-03 14:14:12', 'a@123汉字&^%djgk',
+2, -1.79E+100, 98*0.99, '1010101001010','abca@123&^%djgk', 'abca@123&^%djgk', '2019-01-03 14:14:12',
25563.1415, 'a字符串@123&^%djgk', lpad('10',20,'01010'),'1001010', '2019-01-03 14:14:12',
'010101111111100000000000000', 'abc&GDsh', '2019-01-03 15:19:00', 0.655841541,1);
end loop;
end;
/

